CREATE TABLE [dbo].[tb_ConceptosDePuntaje]
(
[idConcepto] [int] NOT NULL IDENTITY(1, 1),
[Descripcion] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NroDeOrden] [int] NULL,
[TipoConvocatoria] [int] NULL,
[FormulaPuntaje] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Recalcular] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_tb_ConceptosDePuntaje_Recalcular] DEFAULT ('1')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_ConceptosDePuntaje] ADD CONSTRAINT [PK_tb_ConceptosDePuntaje] PRIMARY KEY CLUSTERED  ([idConcepto]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ind_tipoConvocatoriaConcepto] ON [dbo].[tb_ConceptosDePuntaje] ([idConcepto], [TipoConvocatoria]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ind_nrodeorden] ON [dbo].[tb_ConceptosDePuntaje] ([NroDeOrden]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_ConceptosDePuntaje] WITH NOCHECK ADD CONSTRAINT [FK_tb_ConceptosDePuntaje_tb_TiposDeConvocatorias] FOREIGN KEY ([TipoConvocatoria]) REFERENCES [dbo].[tb_TiposDeConvocatorias] ([idTipoConvocatoria])
GO
GRANT SELECT ON  [dbo].[tb_ConceptosDePuntaje] TO [Juntas]
GO
